package com.sino.operation.mapper;

import com.sino.operation.dto.inner.TaskQueue;
import com.sino.operation.dto.out.NetHandleEntity;
import com.sino.operation.entity.BizTranslist;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 流水表 Mapper 接口
 * </p>
 *
 * @author admin
 * @since 2021-10-07
 */
public interface BizTranslistMapper extends BaseMapper<BizTranslist> {

    @Select("select count(*) from biz_translist")
    public String getSequence();

    public int getTransListByNetHandleCount(String tellerNo,String start,String end,String printNum,String kernelNo,String journalNo,String transState,String orgCode);

    public List<NetHandleEntity> getTransListByNetHandleList(String tellerNo, String start, String end, String printNum, String kernelNo, String journalNo, String transState, String orgCode);

    Map selectMapById(@Param("journalNo") String journalNo);

    public int getTransListForNetHandleCount(@Param("tellerCode") String tellerCode,@Param("taskNo") String taskNo,@Param("startTime") String startTime,@Param("endTime") String endTime,@Param("taskStatus") String taskStatus,@Param("transType") String transType,@Param("centerNo") String centerNo);

    public List<TaskQueue> getTransListForNetHandleList(@Param("tellerCode") String tellerCode,@Param("taskNo") String taskNo,@Param("startTime") String startTime,@Param("endTime") String endTime,@Param("taskStatus") String taskStatus,@Param("transType") String transType,@Param("centerNo") String centerNo);
}
